/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.56.6
 Source Server Type    : MySQL
 Source Server Version : 50643
 Source Host           : 192.168.56.6:3306
 Source Schema         : mall

 Target Server Type    : MySQL
 Target Server Version : 50643
 File Encoding         : 65001

 Date: 08/10/2019 22:48:38
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ACT_EVT_LOG
-- ----------------------------
DROP TABLE IF EXISTS `ACT_EVT_LOG`;
CREATE TABLE `ACT_EVT_LOG` (
  `LOG_NR_` bigint(20) NOT NULL AUTO_INCREMENT,
  `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DATA_` longblob,
  `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  `IS_PROCESSED_` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`LOG_NR_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_GE_BYTEARRAY
-- ----------------------------
DROP TABLE IF EXISTS `ACT_GE_BYTEARRAY`;
CREATE TABLE `ACT_GE_BYTEARRAY` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `REV_` int(11) DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `BYTES_` longblob,
  `GENERATED_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`),
  CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_GE_PROPERTY
-- ----------------------------
DROP TABLE IF EXISTS `ACT_GE_PROPERTY`;
CREATE TABLE `ACT_GE_PROPERTY` (
  `NAME_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL,
  `REV_` int(11) DEFAULT NULL,
  PRIMARY KEY (`NAME_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of ACT_GE_PROPERTY
-- ----------------------------
BEGIN;
INSERT INTO `ACT_GE_PROPERTY` VALUES ('cfg.execution-related-entities-count', 'false', 1);
INSERT INTO `ACT_GE_PROPERTY` VALUES ('next.dbid', '1', 1);
INSERT INTO `ACT_GE_PROPERTY` VALUES ('schema.history', 'create(7.0.0.0)', 1);
INSERT INTO `ACT_GE_PROPERTY` VALUES ('schema.version', '7.0.0.0', 1);
COMMIT;

-- ----------------------------
-- Table structure for ACT_HI_ACTINST
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_ACTINST`;
CREATE TABLE `ACT_HI_ACTINST` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint(20) DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`),
  KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`),
  KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`),
  KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_ATTACHMENT
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_ATTACHMENT`;
CREATE TABLE `ACT_HI_ATTACHMENT` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `URL_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `CONTENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TIME_` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_COMMENT
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_COMMENT`;
CREATE TABLE `ACT_HI_COMMENT` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TIME_` datetime(3) NOT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACTION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `MESSAGE_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `FULL_MSG_` longblob,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_DETAIL
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_DETAIL`;
CREATE TABLE `ACT_HI_DETAIL` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACT_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  `VAR_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TIME_` datetime(3) NOT NULL,
  `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint(20) DEFAULT NULL,
  `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`),
  KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`),
  KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`),
  KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`),
  KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_IDENTITYLINK
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_IDENTITYLINK`;
CREATE TABLE `ACT_HI_IDENTITYLINK` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`),
  KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`),
  KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_PROCINST
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_PROCINST`;
CREATE TABLE `ACT_HI_PROCINST` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint(20) DEFAULT NULL,
  `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `END_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `SUPER_PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`),
  KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`),
  KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_TASKINST
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_TASKINST`;
CREATE TABLE `ACT_HI_TASKINST` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `CLAIM_TIME_` datetime(3) DEFAULT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint(20) DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `PRIORITY_` int(11) DEFAULT NULL,
  `DUE_DATE_` datetime(3) DEFAULT NULL,
  `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_HI_VARINST
-- ----------------------------
DROP TABLE IF EXISTS `ACT_HI_VARINST`;
CREATE TABLE `ACT_HI_VARINST` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  `VAR_TYPE_` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `REV_` int(11) DEFAULT NULL,
  `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint(20) DEFAULT NULL,
  `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `CREATE_TIME_` datetime(3) DEFAULT NULL,
  `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`),
  KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`),
  KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_PROCDEF_INFO
-- ----------------------------
DROP TABLE IF EXISTS `ACT_PROCDEF_INFO`;
CREATE TABLE `ACT_PROCDEF_INFO` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `INFO_JSON_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`),
  KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`),
  CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RE_DEPLOYMENT
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RE_DEPLOYMENT`;
CREATE TABLE `ACT_RE_DEPLOYMENT` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL,
  `ENGINE_VERSION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RE_MODEL
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RE_MODEL`;
CREATE TABLE `ACT_RE_MODEL` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `VERSION_` int(11) DEFAULT NULL,
  `META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EDITOR_SOURCE_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`),
  KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`),
  KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`),
  CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`),
  CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RE_PROCDEF
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RE_PROCDEF`;
CREATE TABLE `ACT_RE_PROCDEF` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `KEY_` varchar(255) COLLATE utf8_bin NOT NULL,
  `VERSION_` int(11) NOT NULL,
  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DGRM_RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `HAS_START_FORM_KEY_` tinyint(4) DEFAULT NULL,
  `HAS_GRAPHICAL_NOTATION_` tinyint(4) DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `ENGINE_VERSION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`,`TENANT_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_DEADLETTER_JOB
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_DEADLETTER_JOB`;
CREATE TABLE `ACT_RU_DEADLETTER_JOB` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_DEADLETTER_JOB_EXECUTION` (`EXECUTION_ID_`),
  KEY `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`),
  KEY `ACT_FK_DEADLETTER_JOB_PROC_DEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_DEADLETTER_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
  CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_EVENT_SUBSCR
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_EVENT_SUBSCR`;
CREATE TABLE `ACT_RU_EVENT_SUBSCR` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `EVENT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `EVENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACTIVITY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `CONFIGURATION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CREATED_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`),
  KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`),
  CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_EXECUTION
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_EXECUTION`;
CREATE TABLE `ACT_RU_EXECUTION` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `REV_` int(11) DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PARENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `SUPER_EXEC_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ROOT_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `IS_ACTIVE_` tinyint(4) DEFAULT NULL,
  `IS_CONCURRENT_` tinyint(4) DEFAULT NULL,
  `IS_SCOPE_` tinyint(4) DEFAULT NULL,
  `IS_EVENT_SCOPE_` tinyint(4) DEFAULT NULL,
  `IS_MI_ROOT_` tinyint(4) DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
  `CACHED_ENT_STATE_` int(11) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `START_TIME_` datetime(3) DEFAULT NULL,
  `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  `IS_COUNT_ENABLED_` tinyint(4) DEFAULT NULL,
  `EVT_SUBSCR_COUNT_` int(11) DEFAULT NULL,
  `TASK_COUNT_` int(11) DEFAULT NULL,
  `JOB_COUNT_` int(11) DEFAULT NULL,
  `TIMER_JOB_COUNT_` int(11) DEFAULT NULL,
  `SUSP_JOB_COUNT_` int(11) DEFAULT NULL,
  `DEADLETTER_JOB_COUNT_` int(11) DEFAULT NULL,
  `VAR_COUNT_` int(11) DEFAULT NULL,
  `ID_LINK_COUNT_` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`),
  KEY `ACT_IDC_EXEC_ROOT` (`ROOT_PROC_INST_ID_`),
  KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`),
  KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`),
  KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`),
  KEY `ACT_FK_EXE_PROCDEF` (`PROC_DEF_ID_`),
  CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE,
  CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_IDENTITYLINK
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_IDENTITYLINK`;
CREATE TABLE `ACT_RU_IDENTITYLINK` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `REV_` int(11) DEFAULT NULL,
  `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`),
  KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`),
  KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`),
  KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`),
  CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `ACT_RU_TASK` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_INTEGRATION
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_INTEGRATION`;
CREATE TABLE `ACT_RU_INTEGRATION` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `FLOW_NODE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `CREATED_DATE_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_INT_EXECUTION` (`EXECUTION_ID_`),
  KEY `ACT_FK_INT_PROC_INST` (`PROCESS_INSTANCE_ID_`),
  KEY `ACT_FK_INT_PROC_DEF` (`PROC_DEF_ID_`),
  CONSTRAINT `ACT_FK_INT_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE,
  CONSTRAINT `ACT_FK_INT_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  CONSTRAINT `ACT_FK_INT_PROC_INST` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_JOB
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_JOB`;
CREATE TABLE `ACT_RU_JOB` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `RETRIES_` int(11) DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_JOB_EXECUTION` (`EXECUTION_ID_`),
  KEY `ACT_FK_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`),
  KEY `ACT_FK_JOB_PROC_DEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
  CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  CONSTRAINT `ACT_FK_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_SUSPENDED_JOB
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_SUSPENDED_JOB`;
CREATE TABLE `ACT_RU_SUSPENDED_JOB` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `RETRIES_` int(11) DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_SUSPENDED_JOB_EXECUTION` (`EXECUTION_ID_`),
  KEY `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`),
  KEY `ACT_FK_SUSPENDED_JOB_PROC_DEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_SUSPENDED_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
  CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_TASK
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_TASK`;
CREATE TABLE `ACT_RU_TASK` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `REV_` int(11) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DELEGATION_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PRIORITY_` int(11) DEFAULT NULL,
  `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `DUE_DATE_` datetime(3) DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CLAIM_TIME_` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`),
  KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`),
  KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`),
  KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`),
  CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_TIMER_JOB
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_TIMER_JOB`;
CREATE TABLE `ACT_RU_TIMER_JOB` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `RETRIES_` int(11) DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_TIMER_JOB_EXECUTION` (`EXECUTION_ID_`),
  KEY `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`),
  KEY `ACT_FK_TIMER_JOB_PROC_DEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_TIMER_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
  CONSTRAINT `ACT_FK_TIMER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  CONSTRAINT `ACT_FK_TIMER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_TIMER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for ACT_RU_VARIABLE
-- ----------------------------
DROP TABLE IF EXISTS `ACT_RU_VARIABLE`;
CREATE TABLE `ACT_RU_VARIABLE` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint(20) DEFAULT NULL,
  `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`),
  KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`),
  KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`),
  KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`),
  CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for QRTZ_BLOB_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`;
CREATE TABLE `QRTZ_BLOB_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_CALENDARS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CALENDARS`;
CREATE TABLE `QRTZ_CALENDARS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(200) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_CRON_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`;
CREATE TABLE `QRTZ_CRON_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `CRON_EXPRESSION` varchar(200) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_FIRED_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`;
CREATE TABLE `QRTZ_FIRED_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(200) DEFAULT NULL,
  `JOB_GROUP` varchar(200) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_JOB_DETAILS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;
CREATE TABLE `QRTZ_JOB_DETAILS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_LOCKS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_LOCKS`;
CREATE TABLE `QRTZ_LOCKS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of QRTZ_LOCKS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_LOCKS` VALUES ('ClassbroScheduler', 'STATE_ACCESS');
INSERT INTO `QRTZ_LOCKS` VALUES ('ClassbroScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_PAUSED_TRIGGER_GRPS`;
CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_SCHEDULER_STATE
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`;
CREATE TABLE `QRTZ_SCHEDULER_STATE` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of QRTZ_SCHEDULER_STATE
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_SCHEDULER_STATE` VALUES ('ClassbroScheduler', 'GFox-2.local1570545626309', 1570546109086, 15000);
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_SIMPLE_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPROP_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPROP_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_SIMPROP_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for QRTZ_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_TRIGGERS`;
CREATE TABLE `QRTZ_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  CONSTRAINT `QRTZ_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `QRTZ_JOB_DETAILS` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for schedule_job
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job`;
CREATE TABLE `schedule_job` (
  `id` bigint(80) DEFAULT NULL COMMENT '任务ID',
  `bean_name` varchar(80) DEFAULT NULL COMMENT 'spring bean名称',
  `method_name` varchar(80) DEFAULT NULL COMMENT '方法名',
  `params` varchar(0) DEFAULT NULL COMMENT '参数',
  `cron_expression` varchar(200) DEFAULT NULL COMMENT 'cron表达式',
  `status` int(5) DEFAULT NULL COMMENT '任务状态',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for schedule_job_log
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job_log`;
CREATE TABLE `schedule_job_log` (
  `log_id` decimal(30,0) DEFAULT NULL COMMENT '日志id',
  `job_id` decimal(30,0) DEFAULT NULL COMMENT '任务id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `method_name` varchar(200) DEFAULT NULL COMMENT '方法名',
  `params` varchar(200) DEFAULT NULL COMMENT '参数',
  `status` int(10) DEFAULT NULL COMMENT '任务状态:0成功 1失败',
  `error` varchar(500) DEFAULT NULL COMMENT '失败信息',
  `times` bigint(10) DEFAULT NULL COMMENT '耗时(单位:毫秒)',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for sys_file_detail
-- ----------------------------
DROP TABLE IF EXISTS `sys_file_detail`;
CREATE TABLE `sys_file_detail` (
  `id` bigint(40) NOT NULL COMMENT '附件id',
  `container_id` bigint(20) DEFAULT NULL COMMENT '归属信息id',
  `file_category` varchar(50) DEFAULT NULL COMMENT '附件类别',
  `logical_name` varchar(300) DEFAULT NULL COMMENT '附件名（逻辑名）',
  `description` varchar(2000) DEFAULT NULL COMMENT '附件资料描述',
  `extention_name` varchar(50) DEFAULT NULL COMMENT '附件扩展名',
  `physical_name` varchar(300) DEFAULT NULL COMMENT '附件名（物理名）',
  `file_size` bigint(40) DEFAULT NULL COMMENT '附件大小（KB）',
  `file_content` varchar(300) DEFAULT NULL COMMENT '文件内容',
  `doc_server_id` bigint(40) DEFAULT NULL COMMENT '文件主机id',
  `doc_server_address` varchar(40) DEFAULT NULL COMMENT '文件主机地址',
  `server_group` varchar(20) DEFAULT NULL COMMENT '附件组',
  `server_root_dir` varchar(500) DEFAULT NULL COMMENT '文件绝对路径',
  `creator` varchar(40) DEFAULT NULL COMMENT '创建者',
  `creator_ip` varchar(40) DEFAULT NULL COMMENT '创建者ip',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `del_flag` varchar(2) DEFAULT 'N' COMMENT '删除标识',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统附件表';

-- ----------------------------
-- Records of sys_file_detail
-- ----------------------------
BEGIN;
INSERT INTO `sys_file_detail` VALUES (6111111111, NULL, NULL, '79333345254707200', NULL, 'png', 'wKg4G11K2e-AQKnZAAWqj983vqs610.png', 0, NULL, NULL, NULL, 'group2', 'group2/M00/00/00/wKg4G11K2e-AQKnZAAWqj983vqs610.png', NULL, NULL, '2019-08-07 14:02:23', NULL);
INSERT INTO `sys_file_detail` VALUES (6222222222, NULL, NULL, '79349255994609664', NULL, 'png', 'wKg4G11K6MCAFe0_AAcakwPr6xQ398.png', 465555, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11K6MCAFe0_AAcakwPr6xQ398.png', NULL, NULL, '2019-08-07 15:05:37', NULL);
INSERT INTO `sys_file_detail` VALUES (6333333333, NULL, NULL, '81152818160865280', NULL, 'png', 'wKg4G11LRg2Aa3qYAAcakwPr6xQ807.png', 465555, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11LRg2Aa3qYAAcakwPr6xQ807.png', NULL, NULL, '2019-08-12 14:32:20', NULL);
INSERT INTO `sys_file_detail` VALUES (6444444444, NULL, NULL, '84776269383733248', NULL, 'png', 'wKg4G11epw2AI2TCAAT-a-sA4nc660.png', 327275, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11epw2AI2TCAAT-a-sA4nc660.png', NULL, NULL, '2019-08-22 14:30:38', NULL);
INSERT INTO `sys_file_detail` VALUES (6555555555, NULL, NULL, '84777563045498880', NULL, 'png', 'wKg4G11eqEGAfsJNAAT-a-sA4nc346.png', 1, NULL, NULL, NULL, 'group2', 'group2/M00/00/00/wKg4G11eqEGAfsJNAAT-a-sA4nc346.png', NULL, NULL, '2019-08-22 14:35:46', NULL);
INSERT INTO `sys_file_detail` VALUES (7111111111, NULL, NULL, '79333345254707200', NULL, 'png', 'wKg4G11K2e-AQKnZAAWqj983vqs610.png', 0, NULL, NULL, NULL, 'group2', 'group2/M00/00/00/wKg4G11K2e-AQKnZAAWqj983vqs610.png', NULL, NULL, '2019-08-07 14:02:23', NULL);
INSERT INTO `sys_file_detail` VALUES (7222222222, NULL, NULL, '79349255994609664', NULL, 'png', 'wKg4G11K6MCAFe0_AAcakwPr6xQ398.png', 465555, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11K6MCAFe0_AAcakwPr6xQ398.png', NULL, NULL, '2019-08-07 15:05:37', NULL);
INSERT INTO `sys_file_detail` VALUES (7333333333, NULL, NULL, '81152818160865280', NULL, 'png', 'wKg4G11LRg2Aa3qYAAcakwPr6xQ807.png', 465555, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11LRg2Aa3qYAAcakwPr6xQ807.png', NULL, NULL, '2019-08-12 14:32:20', NULL);
INSERT INTO `sys_file_detail` VALUES (7444444444, NULL, NULL, '84776269383733248', NULL, 'png', 'wKg4G11epw2AI2TCAAT-a-sA4nc660.png', 327275, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11epw2AI2TCAAT-a-sA4nc660.png', NULL, NULL, '2019-08-22 14:30:38', NULL);
INSERT INTO `sys_file_detail` VALUES (7555555555, NULL, NULL, '84777563045498880', NULL, 'png', 'wKg4G11eqEGAfsJNAAT-a-sA4nc346.png', 1, NULL, NULL, NULL, 'group2', 'group2/M00/00/00/wKg4G11eqEGAfsJNAAT-a-sA4nc346.png', NULL, NULL, '2019-08-22 14:35:46', NULL);
INSERT INTO `sys_file_detail` VALUES (8111111111, NULL, NULL, '79333345254707200', NULL, 'png', 'wKg4G11K2e-AQKnZAAWqj983vqs610.png', 0, NULL, NULL, NULL, 'group2', 'group2/M00/00/00/wKg4G11K2e-AQKnZAAWqj983vqs610.png', NULL, NULL, '2019-08-07 14:02:23', NULL);
INSERT INTO `sys_file_detail` VALUES (8222222222, NULL, NULL, '79349255994609664', NULL, 'png', 'wKg4G11K6MCAFe0_AAcakwPr6xQ398.png', 465555, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11K6MCAFe0_AAcakwPr6xQ398.png', NULL, NULL, '2019-08-07 15:05:37', NULL);
INSERT INTO `sys_file_detail` VALUES (8333333333, NULL, NULL, '81152818160865280', NULL, 'png', 'wKg4G11LRg2Aa3qYAAcakwPr6xQ807.png', 465555, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11LRg2Aa3qYAAcakwPr6xQ807.png', NULL, NULL, '2019-08-12 14:32:20', NULL);
INSERT INTO `sys_file_detail` VALUES (8444444444, NULL, NULL, '84776269383733248', NULL, 'png', 'wKg4G11epw2AI2TCAAT-a-sA4nc660.png', 327275, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11epw2AI2TCAAT-a-sA4nc660.png', NULL, NULL, '2019-08-22 14:30:38', NULL);
INSERT INTO `sys_file_detail` VALUES (8555555555, NULL, NULL, '84777563045498880', NULL, 'png', 'wKg4G11eqEGAfsJNAAT-a-sA4nc346.png', 1, NULL, NULL, NULL, 'group2', 'group2/M00/00/00/wKg4G11eqEGAfsJNAAT-a-sA4nc346.png', NULL, NULL, '2019-08-22 14:35:46', NULL);
INSERT INTO `sys_file_detail` VALUES (9111111111, NULL, NULL, '79333345254707200', NULL, 'png', 'wKg4G11K2e-AQKnZAAWqj983vqs610.png', 0, NULL, NULL, NULL, 'group2', 'group2/M00/00/00/wKg4G11K2e-AQKnZAAWqj983vqs610.png', NULL, NULL, '2019-08-07 14:02:23', NULL);
INSERT INTO `sys_file_detail` VALUES (9222222222, NULL, NULL, '79349255994609664', NULL, 'png', 'wKg4G11K6MCAFe0_AAcakwPr6xQ398.png', 465555, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11K6MCAFe0_AAcakwPr6xQ398.png', NULL, NULL, '2019-08-07 15:05:37', NULL);
INSERT INTO `sys_file_detail` VALUES (9333333333, NULL, NULL, '81152818160865280', NULL, 'png', 'wKg4G11LRg2Aa3qYAAcakwPr6xQ807.png', 465555, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11LRg2Aa3qYAAcakwPr6xQ807.png', NULL, NULL, '2019-08-12 14:32:20', NULL);
INSERT INTO `sys_file_detail` VALUES (9444444444, NULL, NULL, '84776269383733248', NULL, 'png', 'wKg4G11epw2AI2TCAAT-a-sA4nc660.png', 327275, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11epw2AI2TCAAT-a-sA4nc660.png', NULL, NULL, '2019-08-22 14:30:38', NULL);
INSERT INTO `sys_file_detail` VALUES (9555555555, NULL, NULL, '84777563045498880', NULL, 'png', 'wKg4G11eqEGAfsJNAAT-a-sA4nc346.png', 1, NULL, NULL, NULL, 'group2', 'group2/M00/00/00/wKg4G11eqEGAfsJNAAT-a-sA4nc346.png', NULL, NULL, '2019-08-22 14:35:46', NULL);
INSERT INTO `sys_file_detail` VALUES (79333345254707200, NULL, NULL, '79333345254707200', NULL, 'png', 'wKg4G11K2e-AQKnZAAWqj983vqs610.png', 0, NULL, NULL, NULL, 'group2', 'group2/M00/00/00/wKg4G11K2e-AQKnZAAWqj983vqs610.png', NULL, NULL, '2019-08-07 14:02:23', NULL);
INSERT INTO `sys_file_detail` VALUES (79349255994609664, NULL, NULL, '79349255994609664', NULL, 'png', 'wKg4G11K6MCAFe0_AAcakwPr6xQ398.png', 465555, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11K6MCAFe0_AAcakwPr6xQ398.png', NULL, NULL, '2019-08-07 15:05:37', NULL);
INSERT INTO `sys_file_detail` VALUES (81152818160865280, NULL, NULL, '81152818160865280', NULL, 'png', 'wKg4G11LRg2Aa3qYAAcakwPr6xQ807.png', 465555, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11LRg2Aa3qYAAcakwPr6xQ807.png', NULL, NULL, '2019-08-12 14:32:20', NULL);
INSERT INTO `sys_file_detail` VALUES (84776269383733248, NULL, NULL, '84776269383733248', NULL, 'png', 'wKg4G11epw2AI2TCAAT-a-sA4nc660.png', 327275, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11epw2AI2TCAAT-a-sA4nc660.png', NULL, NULL, '2019-08-22 14:30:38', NULL);
INSERT INTO `sys_file_detail` VALUES (84777563045498880, NULL, NULL, '84777563045498880', NULL, 'png', 'wKg4G11eqEGAfsJNAAT-a-sA4nc346.png', 1, NULL, NULL, NULL, 'group2', 'group2/M00/00/00/wKg4G11eqEGAfsJNAAT-a-sA4nc346.png', NULL, NULL, '2019-08-22 14:35:46', NULL);
INSERT INTO `sys_file_detail` VALUES (90073223282036736, NULL, NULL, '90073223282036736', NULL, 'jpg', 'wKg4G11tMdqAS4nxAAdRm4ICIIk546.jpg', 479643, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11tMdqAS4nxAAdRm4ICIIk546.jpg', NULL, NULL, '2019-09-06 05:18:51', NULL);
INSERT INTO `sys_file_detail` VALUES (97676642998030336, NULL, NULL, '11111', NULL, 'png', 'wKg4G11wayOADavbAAB0B8zSr-0244.png', 29703, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wayOADavbAAB0B8zSr-0244.png', NULL, NULL, '2019-09-27 04:52:06', NULL);
INSERT INTO `sys_file_detail` VALUES (97677316951379968, NULL, NULL, '01b11b57826b210000018c1beb6bed.jpg@2o.jpg', NULL, 'jpg', 'wKg4G11wa9GADgTlAAB7_4grDRk895.jpg', 31743, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wa9GADgTlAAB7_4grDRk895.jpg', NULL, NULL, '2019-09-27 04:54:47', NULL);
INSERT INTO `sys_file_detail` VALUES (97677316968157184, NULL, NULL, '404@1280w_1l_2o_100sh', NULL, 'png', 'wKg4G11wa9GAFTu_AAJhL6sUFfA946.png', 155951, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wa9GAFTu_AAJhL6sUFfA946.png', NULL, NULL, '2019-09-27 04:54:47', NULL);
INSERT INTO `sys_file_detail` VALUES (97677316972351488, NULL, NULL, '404.jpg@2o.jpg', NULL, 'jpg', 'wKg4G11wa9GALknrAAIdglWQOGI620.jpg', 138626, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wa9GALknrAAIdglWQOGI620.jpg', NULL, NULL, '2019-09-27 04:54:47', NULL);
INSERT INTO `sys_file_detail` VALUES (97797740490133504, NULL, NULL, '404.jpg@2o.jpg', NULL, 'jpg', 'wKg4G11wefaAc9kKAAIdglWQOGI627.jpg', 138626, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wefaAc9kKAAIdglWQOGI627.jpg', NULL, NULL, '2019-09-27 12:53:18', NULL);
INSERT INTO `sys_file_detail` VALUES (97797740494327808, NULL, NULL, '500@1280w_1l_2o_100sh', NULL, 'png', 'wKg4G11wefaADRzfAAKvvgmGdhM747.png', 176062, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wefaADRzfAAKvvgmGdhM747.png', NULL, NULL, '2019-09-27 12:53:18', NULL);
INSERT INTO `sys_file_detail` VALUES (97798207249059840, NULL, NULL, '404-1.zip', NULL, 'zip', 'wKg4G11wem6AJTPGAAURwyr72cw651.zip', 332227, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wem6AJTPGAAURwyr72cw651.zip', NULL, NULL, '2019-09-27 12:55:10', NULL);
INSERT INTO `sys_file_detail` VALUES (97799449924866048, NULL, NULL, 'Constant.java', NULL, 'java', 'wKg4G11we6-AFfsoAAAH4QDcRdA16.java', 2017, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11we6-AFfsoAAAH4QDcRdA16.java', NULL, NULL, '2019-09-27 13:00:06', NULL);
INSERT INTO `sys_file_detail` VALUES (97804126104064000, NULL, NULL, '11111', NULL, 'png', 'wKg4G11wgGeAflQoAAB0B8zSr-0446.png', 29703, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wgGeAflQoAAB0B8zSr-0446.png', NULL, NULL, '2019-09-27 13:18:41', NULL);
INSERT INTO `sys_file_detail` VALUES (97806595328577536, NULL, NULL, '18025', NULL, 'jpg', 'wKg4G11wguWAJhprAAdRm4ICIIk589.jpg', 479643, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wguWAJhprAAdRm4ICIIk589.jpg', NULL, NULL, '2019-09-27 13:28:29', NULL);
INSERT INTO `sys_file_detail` VALUES (97806595383103488, NULL, NULL, '18099', NULL, 'jpg', 'wKg4G11wguWAUQbtAAlnpOKg4eU328.jpg', 616356, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wguWAUQbtAAlnpOKg4eU328.jpg', NULL, NULL, '2019-09-27 13:28:29', NULL);
INSERT INTO `sys_file_detail` VALUES (97806595387297792, NULL, NULL, '18107', NULL, 'jpg', 'wKg4G11wguWAZ5NAAAcakwPr6xQ677.jpg', 465555, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wguWAZ5NAAAcakwPr6xQ677.jpg', NULL, NULL, '2019-09-27 13:28:29', NULL);
INSERT INTO `sys_file_detail` VALUES (97815957409370112, NULL, '', '18025', '', 'jpg', 'wKg4G11wjFeASOy6AAdRm4ICIIk978.jpg', 479643, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wjFeASOy6AAdRm4ICIIk978.jpg', NULL, NULL, '2019-09-27 14:05:42', NULL);
INSERT INTO `sys_file_detail` VALUES (97816483983265792, NULL, '', '18105', '', 'jpg', 'wKg4G11wjN-ANQM_AAWpw0fF5J4850.jpg', 371139, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wjN-ANQM_AAWpw0fF5J4850.jpg', NULL, NULL, '2019-09-27 14:07:47', NULL);
INSERT INTO `sys_file_detail` VALUES (97817967785414656, NULL, '', '18025', '', 'jpg', 'wKg4G11wjl6ATykqAAdRm4ICIIk864.jpg', 479643, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wjl6ATykqAAdRm4ICIIk864.jpg', NULL, NULL, '2019-09-27 14:13:41', NULL);
INSERT INTO `sys_file_detail` VALUES (97818358069596160, NULL, '222222', '500.jpg@1280w_1l_2o_100sh', '', 'jpg', 'wKg4G11wjsOAVbZlAAFfcNWyW0w282.jpg', 89968, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wjsOAVbZlAAFfcNWyW0w282.jpg', NULL, NULL, '2019-09-27 14:15:14', NULL);
INSERT INTO `sys_file_detail` VALUES (97820104980434944, NULL, '222222', '18025', '', 'jpg', 'wKg4G11wkIaAY0dFAAdRm4ICIIk774.jpg', 479643, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wkIaAY0dFAAdRm4ICIIk774.jpg', NULL, NULL, '2019-09-27 14:22:10', NULL);
INSERT INTO `sys_file_detail` VALUES (97820382144237568, NULL, '222222', '500.png@1280w_1l_2o_100sh', 'sddd', 'png', 'wKg4G11wkM6AbKlGAAKvvgmGdhM600.png', 176062, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wkM6AbKlGAAKvvgmGdhM600.png', NULL, NULL, '2019-09-27 14:23:17', NULL);
INSERT INTO `sys_file_detail` VALUES (97822265864884224, NULL, '222222', '18025', 'sddd', 'jpg', 'wKg4G11wkrSAcGWQAAdRm4ICIIk145.jpg', 479643, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wkrSAcGWQAAdRm4ICIIk145.jpg', NULL, NULL, '2019-09-27 14:30:46', NULL);
INSERT INTO `sys_file_detail` VALUES (97822392885186560, NULL, '222222', '500.jpg@1280w_1l_2o_100sh', 'sddd', 'jpg', 'wKg4G11wktWAfzJZAAFfcNWyW0w882.jpg', 89968, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wktWAfzJZAAFfcNWyW0w882.jpg', NULL, NULL, '2019-09-27 14:31:16', NULL);
INSERT INTO `sys_file_detail` VALUES (97845131247357952, NULL, '222222', '1', 'sddd', 'pdf', 'wKg4G11wqcaAcmH4AAC5icX3-2Q286.pdf', 47497, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wqcaAcmH4AAC5icX3-2Q286.pdf', NULL, NULL, '2019-09-27 16:01:37', NULL);
INSERT INTO `sys_file_detail` VALUES (97845131247357953, NULL, '222222', '18105', 'sddd', 'jpg', 'wKg4G11wqcaAGHmqAAWpw0fF5J4626.jpg', 371139, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11wqcaAGHmqAAWpw0fF5J4626.jpg', NULL, NULL, '2019-09-27 16:01:37', NULL);
INSERT INTO `sys_file_detail` VALUES (101807915031072768, NULL, '222222', '11111', 'sddd', 'png', 'wKg4G11xR_WAb664AAB0B8zSr-0934.png', 29703, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11xR_WAb664AAB0B8zSr-0934.png', NULL, NULL, '2019-10-08 14:28:18', NULL);
INSERT INTO `sys_file_detail` VALUES (101808833105498112, NULL, '222222', '404.png@1280w_1l_2o_100sh', 'sddd', 'png', 'wKg4G11xSOKAAjr0AAJhL6sUFfA005.png', 155951, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11xSOKAAjr0AAJhL6sUFfA005.png', NULL, NULL, '2019-10-08 14:31:57', NULL);
INSERT INTO `sys_file_detail` VALUES (101809190791548928, NULL, '222222', '404.jpg@2o', 'sddd', 'jpg', 'wKg4G11xST6APDMeAAIdglWQOGI314.jpg', 138626, NULL, NULL, '192.168.56.27', 'group2', 'group2/M00/00/00/wKg4G11xST6APDMeAAIdglWQOGI314.jpg', NULL, NULL, '2019-10-08 14:33:23', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_log_operation
-- ----------------------------
DROP TABLE IF EXISTS `sys_log_operation`;
CREATE TABLE `sys_log_operation` (
  `id` bigint(40) NOT NULL COMMENT 'id',
  `operation` varchar(50) DEFAULT NULL COMMENT '用户操作',
  `request_uri` varchar(200) DEFAULT NULL COMMENT '请求URI',
  `request_method` varchar(20) DEFAULT NULL COMMENT '请求方式',
  `request_params` text COMMENT '请求参数',
  `request_time` int(10) unsigned NOT NULL COMMENT '请求时长(毫秒)',
  `user_agent` varchar(500) DEFAULT NULL COMMENT '用户代理',
  `ip` varchar(32) DEFAULT NULL COMMENT '操作IP',
  `status` int(3) unsigned NOT NULL COMMENT '状态  0：失败   1：成功',
  `creator_name` varchar(50) DEFAULT NULL COMMENT '用户名',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='操作日志';

-- ----------------------------
-- Records of sys_log_operation
-- ----------------------------
BEGIN;
INSERT INTO `sys_log_operation` VALUES (56495623867731968, 'temp', '/test/testMethod', 'GET', NULL, 12, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, NULL);
INSERT INTO `sys_log_operation` VALUES (56495937698140160, 'temp', '/test/testMethod', 'GET', NULL, 2, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, NULL);
INSERT INTO `sys_log_operation` VALUES (56496545201131520, 'temp', '/test/testMethod', 'GET', NULL, 55652, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, NULL);
INSERT INTO `sys_log_operation` VALUES (78244144991965184, NULL, NULL, NULL, NULL, 11111, NULL, NULL, 1, NULL, NULL, NULL);
INSERT INTO `sys_log_operation` VALUES (78245381984489472, NULL, NULL, NULL, NULL, 11111, NULL, NULL, 1, NULL, NULL, NULL);
INSERT INTO `sys_log_operation` VALUES (78252553413857280, NULL, NULL, NULL, NULL, 11111, NULL, NULL, 1, NULL, NULL, NULL);
INSERT INTO `sys_log_operation` VALUES (78257524356157440, NULL, NULL, NULL, NULL, 11111, NULL, NULL, 1, NULL, NULL, NULL);
INSERT INTO `sys_log_operation` VALUES (78257670888361984, NULL, NULL, NULL, NULL, 11111, NULL, NULL, 1, NULL, NULL, NULL);
INSERT INTO `sys_log_operation` VALUES (81158820692234240, 'temp', '/test/testMethod', 'GET', NULL, 9, 'PostmanRuntime/7.15.2', '0:0:0:0:0:0:0:1', 1, NULL, NULL, NULL);
INSERT INTO `sys_log_operation` VALUES (81159085575114752, 'temp', '/test/testMethod', 'GET', NULL, 2, 'PostmanRuntime/7.15.2', '0:0:0:0:0:0:0:1', 1, NULL, NULL, NULL);
INSERT INTO `sys_log_operation` VALUES (101790642404855808, 'SysUser', '/users', 'GET', NULL, 70, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:19:40');
INSERT INTO `sys_log_operation` VALUES (101790699308978176, 'SysUser', '/users', 'GET', NULL, 13, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:19:54');
INSERT INTO `sys_log_operation` VALUES (101790915621818368, 'SysUser', '/users', 'GET', NULL, 9, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:20:45');
INSERT INTO `sys_log_operation` VALUES (101790959615873024, 'SysUser', '/users', 'GET', NULL, 9, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:20:56');
INSERT INTO `sys_log_operation` VALUES (101791006977953792, 'SysUser', '/users', 'GET', NULL, 12, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:21:07');
INSERT INTO `sys_log_operation` VALUES (101792409062477824, 'SysUser', '/users', 'GET', NULL, 6, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:26:42');
INSERT INTO `sys_log_operation` VALUES (101792429941723136, 'SysUser', '/users', 'GET', NULL, 6, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:26:47');
INSERT INTO `sys_log_operation` VALUES (101792449839501312, 'SysUser', '/users', 'GET', NULL, 5, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:26:51');
INSERT INTO `sys_log_operation` VALUES (101792512275910656, 'SysUser', '/users', 'GET', NULL, 7, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:27:06');
INSERT INTO `sys_log_operation` VALUES (101793331704500224, 'SysUser', '/users', 'GET', NULL, 7, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:30:22');
INSERT INTO `sys_log_operation` VALUES (101793358438993920, 'SysUser', '/users', 'GET', NULL, 6, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:30:28');
INSERT INTO `sys_log_operation` VALUES (101793460083757056, 'SysUser', '/users', 'GET', NULL, 6, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:30:52');
INSERT INTO `sys_log_operation` VALUES (101793543302942720, 'SysUser', '/users', 'GET', NULL, 7, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:31:12');
INSERT INTO `sys_log_operation` VALUES (101793576991592448, 'SysUser', '/users', 'GET', NULL, 7, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:31:20');
INSERT INTO `sys_log_operation` VALUES (101793604791439360, 'SysUser', '/users', 'GET', NULL, 6, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:31:27');
INSERT INTO `sys_log_operation` VALUES (101793633790857216, 'SysUser', '/users', 'GET', NULL, 6, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:31:34');
INSERT INTO `sys_log_operation` VALUES (101798583728082944, 'SysUser', '/users', 'GET', NULL, 16, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.90 Safari/537.36', '0:0:0:0:0:0:0:1', 1, NULL, NULL, '2019-10-08 13:51:14');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint(40) NOT NULL COMMENT 'id',
  `name` varchar(255) DEFAULT NULL COMMENT '菜单名称',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级ID，一级菜单为0',
  `url` varchar(200) DEFAULT NULL COMMENT '菜单URL',
  `permissions` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：sys:user:list,sys:user:save)',
  `type` tinyint(3) unsigned DEFAULT NULL COMMENT '类型   0：菜单   1：按钮',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_pid` (`pid`),
  KEY `idx_sort` (`sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='菜单管理';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (86444346110382080, '一级菜单', 0, '', NULL, 0, 'mdi mdi-chart-bar', 3, NULL, '2019-08-27 04:58:58', NULL, NULL);
INSERT INTO `sys_menu` VALUES (86444346789859328, '菜单', 86444346110382080, 'demo/test003', 'test:demo:menu003', 0, 'mdi mdi-access-point', 1, NULL, '2019-08-27 04:58:58', NULL, NULL);
INSERT INTO `sys_menu` VALUES (86444346810830848, '文件', 86444346110382080, 'file/fileList.htm', 'test:demo:menu004', 0, 'mdi mdi-comment-text', 1, NULL, '2019-08-27 04:58:58', NULL, NULL);
INSERT INTO `sys_menu` VALUES (86444346827608064, '新增文件', 86444346110382080, 'file/addFile.htm', 'test:demo:menu005', 0, 'mdi mdi-access-point', 1, NULL, '2019-08-27 04:58:58', NULL, NULL);
INSERT INTO `sys_menu` VALUES (86444346856968192, '日志', 86444346110382080, 'log/logList.htm', 'test:demo:menu007', 0, 'mdi mdi-access-point', 1, NULL, '2019-08-27 04:58:58', NULL, NULL);
INSERT INTO `sys_menu` VALUES (86444346873745408, '用户', 86444346110382080, 'user/userList.htm', 'test:demo:menu008', 0, 'mdi mdi-access-point', 1, NULL, '2019-08-27 04:58:58', NULL, NULL);
INSERT INTO `sys_menu` VALUES (95180275016798208, '系统管理', 0, '', NULL, 0, 'mdi mdi-settings', 1, NULL, '2019-09-20 07:32:26', NULL, NULL);
INSERT INTO `sys_menu` VALUES (95180832645320704, '菜单管理', 95180275016798208, 'menu/menuList.htm', 'test:demo:button09', 1, 'mdi mdi-calendar-text', 0, NULL, '2019-09-20 07:34:39', NULL, NULL);
INSERT INTO `sys_menu` VALUES (95180943907622912, '角色管理', 95180275016798208, 'role/roleList.htm', 'test:demo:button09', 1, 'mdi mdi-account-box', 0, NULL, '2019-09-20 07:35:05', NULL, NULL);
INSERT INTO `sys_menu` VALUES (95181029253320704, '用户管理', 95180275016798208, 'user/userList.htm', 'test:demo:button09', 1, 'mdi mdi-account-settings-variant', 0, NULL, '2019-09-20 07:35:26', NULL, NULL);
INSERT INTO `sys_menu` VALUES (95193772383539200, '系统监控', 0, '', NULL, 0, 'mdi mdi-heart-pulse', 1, NULL, '2019-09-20 08:26:04', NULL, NULL);
INSERT INTO `sys_menu` VALUES (95194139708100608, '系统日志', 95193772383539200, 'log/logList.htm', '', 1, 'mdi mdi-file-document', 1, NULL, '2019-09-20 08:27:32', NULL, NULL);
INSERT INTO `sys_menu` VALUES (95194198910701568, '测试页面', 95193772383539200, 'menu/menuList.htm', '', 1, 'mdi mdi-home', 1, NULL, '2019-09-20 08:27:46', NULL, NULL);
INSERT INTO `sys_menu` VALUES (95194617800036352, '文件管理', 0, '', NULL, 0, 'mdi mdi-file-multiple', 2, NULL, '2019-09-20 08:29:26', NULL, NULL);
INSERT INTO `sys_menu` VALUES (95194908645658624, '系统文件', 95194617800036352, 'file/fileList.htm', '', 1, 'mdi mdi-folder-multiple', 1, NULL, '2019-09-20 08:30:35', NULL, NULL);
INSERT INTO `sys_menu` VALUES (95195033480728576, '新增文件', 95194617800036352, 'file/addFile.htm', '', 1, 'mdi mdi-file-plus', 1, NULL, '2019-09-20 08:31:05', NULL, NULL);
INSERT INTO `sys_menu` VALUES (95195092825935872, '图库管理', 95194617800036352, 'file/gallerys.htm', '', 1, 'mdi mdi-folder-multiple-image', 1, NULL, '2019-09-20 08:31:19', NULL, NULL);
INSERT INTO `sys_menu` VALUES (95195541960396800, '测试文件', 95194617800036352, 'file/testFile.htm', '', 1, 'mdi mdi-home', 1, NULL, '2019-09-20 08:33:06', NULL, NULL);
INSERT INTO `sys_menu` VALUES (95301726331998208, 'ceshi', 86444346110382080, 'menu/menuList.htm', 'test:demo:menu005', 1, 'mdi mdi-settings-box', 1, NULL, '2019-09-20 15:35:02', NULL, NULL);
INSERT INTO `sys_menu` VALUES (97837372539932672, '数据源监控', 95193772383539200, '/monitor/druid.htm', 'test:demo:menu005', 1, 'mdi mdi-database', 0, NULL, '2019-09-27 15:30:47', NULL, NULL);
insert into `sys_menu` values(102084655754252288,'数据字典',95180275016798208,'/dict/dictList.htm','test:demo:menu005',1,'mdi mdi-sign-text',1,NULL,'2019-10-09 08:47:58',NULL,NULL);
INSERT INTO `sys_menu` VALUES (97840205649678336, 'API接口', 95193772383539200, '/monitor/swagger.htm', 'test:demo:menu005', 1, 'mdi mdi-sign-text', 1, NULL, '2019-09-27 15:42:03', NULL, NULL);
INSERT INTO `sys_menu` VALUES (8644434710023782221, '文件', 86444347007963136, 'file/fileList.htm', 'test:demo:button09', 1, 'mdi-account-check', 1, NULL, '2019-08-27 04:58:58', NULL, NULL);
INSERT INTO `sys_menu` VALUES (8644434710023782222, '文件', 86444347007963136, 'file/fileList.htm', 'test:demo:button09', 1, 'mdi-account-check', 1, NULL, '2019-08-27 04:58:58', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu_copy1
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu_copy1`;
CREATE TABLE `sys_menu_copy1` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级ID，一级菜单为0',
  `url` varchar(200) DEFAULT NULL COMMENT '菜单URL',
  `permissions` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：sys:user:list,sys:user:save)',
  `type` tinyint(3) unsigned DEFAULT NULL COMMENT '类型   0：菜单   1：按钮',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_pid` (`pid`),
  KEY `idx_sort` (`sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='菜单管理';

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `name` varchar(50) DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_dept_id` (`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色管理';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (44444444444, 'role0001', '222222222', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665065127936, 'role000', '', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665312591872, 'role001', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665333563392, 'role002', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665362923520, 'role003', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665388089344, 'role004', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665404866560, 'role005', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665421643776, 'role006', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665438420992, 'role007', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665455198208, 'role008', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665471975424, 'role009', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665488752640, 'role010', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665509724160, 'role011', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665530695680, 'role012', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665543278592, 'role013', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665572638720, 'role015', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665593610240, 'role016', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665618776064, 'role017', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665639747584, 'role018', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
INSERT INTO `sys_role` VALUES (86441665656524800, 'role019', NULL, NULL, NULL, '2019-08-27 04:48:19', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_role_id` (`role_id`),
  KEY `idx_menu_id` (`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色菜单关系';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES (95196934855200768, 86441665362923520, 95194908645658624, NULL, '2019-09-20 08:38:38');
INSERT INTO `sys_role_menu` VALUES (95196935111053312, 86441665312591872, 95194617800036352, NULL, '2019-09-20 08:38:38');
INSERT INTO `sys_role_menu` VALUES (95196935194939392, 86441665543278592, 95195033480728576, NULL, '2019-09-20 08:38:38');
INSERT INTO `sys_role_menu` VALUES (97087540007276544, 86441665065127936, 95180943907622912, NULL, '2019-09-25 13:51:13');
INSERT INTO `sys_role_menu` VALUES (97087540015665152, 86441665065127936, 95193772383539200, NULL, '2019-09-25 13:51:13');
INSERT INTO `sys_role_menu` VALUES (97087540024053760, 86441665065127936, 95194139708100608, NULL, '2019-09-25 13:51:13');
INSERT INTO `sys_role_menu` VALUES (97087540036636672, 86441665065127936, 95194198910701568, NULL, '2019-09-25 13:51:13');
INSERT INTO `sys_role_menu` VALUES (101806296600154112, 44444444444, 86444346110382080, NULL, '2019-10-08 14:21:53');
INSERT INTO `sys_role_menu` VALUES (101806296625319936, 44444444444, 86444346789859328, NULL, '2019-10-08 14:21:53');
INSERT INTO `sys_role_menu` VALUES (101806296637902848, 44444444444, 86444346810830848, NULL, '2019-10-08 14:21:53');
INSERT INTO `sys_role_menu` VALUES (101806296650485760, 44444444444, 86444346827608064, NULL, '2019-10-08 14:21:53');
INSERT INTO `sys_role_menu` VALUES (101806296663068672, 44444444444, 86444346856968192, NULL, '2019-10-08 14:21:53');
INSERT INTO `sys_role_menu` VALUES (101806296679845888, 44444444444, 86444346873745408, NULL, '2019-10-08 14:21:53');
INSERT INTO `sys_role_menu` VALUES (101806296696623104, 44444444444, 95301726331998208, NULL, '2019-10-08 14:21:53');
INSERT INTO `sys_role_menu` VALUES (101806296709206016, 44444444444, 95180275016798208, NULL, '2019-10-08 14:21:53');
INSERT INTO `sys_role_menu` VALUES (101806296721788928, 44444444444, 95180832645320704, NULL, '2019-10-08 14:21:53');
INSERT INTO `sys_role_menu` VALUES (101806296734371840, 44444444444, 95180943907622912, NULL, '2019-10-08 14:21:53');
INSERT INTO `sys_role_menu` VALUES (101806296746954752, 44444444444, 95181029253320704, NULL, '2019-10-08 14:21:53');
INSERT INTO `sys_role_menu` VALUES (101806296759537664, 44444444444, 95193772383539200, NULL, '2019-10-08 14:21:53');
INSERT INTO `sys_role_menu` VALUES (101806296767926272, 44444444444, 95194139708100608, NULL, '2019-10-08 14:21:53');
INSERT INTO `sys_role_menu` VALUES (101806296780509184, 44444444444, 95194198910701568, NULL, '2019-10-08 14:21:53');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_user`;
CREATE TABLE `sys_role_user` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_role_id` (`role_id`),
  KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色用户关系';

-- ----------------------------
-- Records of sys_role_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_user` VALUES (95196846611238912, 86441665593610240, 86440055786180608, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847005503488, 86441665471975424, 86440055702294528, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847030669312, 86441665333563392, 86440055786180608, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847072612352, 86441665438420992, 86440055664545792, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847093583872, 86441665509724160, 86440055664545792, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847114555392, 86441665593610240, 86440055568076800, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847131332608, 86441665572638720, 86440055761014784, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847152304128, 86441665530695680, 86440055761014784, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847173275648, 86441665438420992, 86440055681323008, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847194247168, 86441665543278592, 86440055681323008, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847219412992, 86441665618776064, 86440055593242624, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847244578816, 86441665312591872, 86440055786180608, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847265550336, 86441665530695680, 86440055719071744, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847294910464, 86441665065127936, 86440055719071744, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847320076288, 86441665593610240, 86440055643574272, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847341047808, 44444444444, 86440055740043264, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847374602240, 86441665455198208, 86440055891038208, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847403962368, 86441665388089344, 86440055786180608, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847429128192, 86441665421643776, 86440055551299584, NULL, '2019-09-20 08:38:17');
INSERT INTO `sys_role_user` VALUES (95196847454294016, 86441665333563392, 86440055643574272, NULL, '2019-09-20 08:38:17');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint(40) NOT NULL COMMENT 'id',
  `user_id` varchar(50) NOT NULL COMMENT '用户编号',
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(100) NOT NULL COMMENT '密码',
  `real_name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `head_url` varchar(200) DEFAULT NULL COMMENT '头像',
  `gender` tinyint(3) unsigned DEFAULT NULL COMMENT '性别   0：男   1：女    2：保密',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) DEFAULT NULL COMMENT '手机号',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '归属组织',
  `super_admin` tinyint(3) unsigned DEFAULT NULL COMMENT '超级管理员   0：否   1：是',
  `last_login_date` datetime DEFAULT NULL COMMENT '最后登陆时间',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态  0：停用   1：正常',
  `creator` varchar(50) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` varchar(50) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_username` (`username`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (86440055551299584, '1908001', 'user001', 'c23162ffc1a535af2ee09588469194816e60cb437e30d78c5617b5d3f1304d6a', '222', NULL, NULL, '', NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055568076800, '1908002', 'user002', 'e3ce8de04a926e54c5a1f64b1babd835ae2f43eef75354ebd6c9a86b21d8575c', '111111144422255222', NULL, NULL, '', NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055593242624, '1908003', 'user003', '1bafcb67e3009476f422803e3bda7fd9773c0f3ffee51162fc2abf83c9c9a000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055618408448, '1908004', 'user004', 'ef892ecf414a9d0497e7cf1636c0b0e47ad31993e11f28127bf0d11e2472f5ef', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055643574272, '1908005', 'user005', 'beaa651892ab94db191478989226d6e919a811eb6e32083e5dba8046235d40a8', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055664545792, '1908006', 'user006', 'f8ef0595a4b6508736bfde713027b57ea5ebffa0d218cc1808de417f5c15d78e', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055681323008, '1908007', 'user007', '5b7f93ad974636b90b9123170e0354dca7af0b14ae98eba6819e3b3b248bc46a', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055702294528, '1908008', 'user008', '831b8c438fd7731e8318a8347c9c8723cb2d6ff1e32839f2d555e4e6c7f70b93', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055719071744, '1908009', 'user009', 'e3adc91f1de618b3a9be36acc1cabb8f3798c9d25b4f52e62c3852fbe5efe188', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055740043264, '1908010', 'user010', '7f7e89b08036415f53f9b44afb3c5203ae3e38703fd7a1765c1fd06176cfe6bf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055761014784, '1908011', 'user011', 'e2749b87ca12e4442c398af65237a7de7e8c684ee19850fc41e4458726f0a074', '2222', NULL, NULL, '', NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055786180608, '1908012', 'user012', 'bfcc2f63d1e28af8ff6bb35f275c82a37a95692393a08c08eef7e3031e114897', 'wwww', NULL, NULL, '', NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055807152128, '1908013', 'user013', '67d2edfc7f835e47ddad571818de648eeac9d79f101afae754c8668f2dba48bb', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055823929344, '1908014', 'user014', '9ae6e8ec4af24359c97cd665c9179ce95a5794e3e385e17a0c1a2bdf612351ce', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055844900864, '1908015', 'user015', '8347c9ccdc3c5638455e24215833bd9717263d92d9770aca7a1946ecb64ceb9f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055874260992, '1908016', 'user016', '9c11e7938e1e8f68da5fc5f7d8d2dab74972c73739ebe47e70f45aa55238c047', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055891038208, '1908017', 'user017', 'e6682d93ff2306b1246683d51c73ac8102faa91fe5423f85749923b3364c8adc', 'sssss', NULL, NULL, 'gx@qq.com', NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055916204032, '1908018', 'user018', '92c066bf55c1b5aabc1e184d6c12a6687f779e2f89fea9ea9de4630d35002d6d', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
INSERT INTO `sys_user` VALUES (86440055937175552, '1908019', 'user019', '1924aa5828b2ad4fcc8b97a9e1623dd595b4217e9abb62a33cae2bebfc9a7646', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'ADMIN', '2019-08-27 04:41:55', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for test
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `id` int(11) NOT NULL COMMENT '唯一标示',
  `user_id` varchar(80) DEFAULT NULL COMMENT '用户编号',
  `user_name` varchar(40) DEFAULT NULL COMMENT '用户名称'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of test
-- ----------------------------
BEGIN;
INSERT INTO `test` VALUES (3, 'wangyangdahai', 'wangyangdahai');
INSERT INTO `test` VALUES (4, 'wangyangdahai4', 'wangyangdahai4');
INSERT INTO `test` VALUES (110, '002', 'fengjiangpi');
INSERT INTO `test` VALUES (110, '002', 'fengjiangpi');
INSERT INTO `test` VALUES (110, '002', 'fengjiangpi');
INSERT INTO `test` VALUES (110, '002', 'fengjiangpi');
INSERT INTO `test` VALUES (110, '002', 'fengjiangpi');
INSERT INTO `test` VALUES (110, '002', 'fengjiangpi');
INSERT INTO `test` VALUES (1101, '002', 'fengjiangpi');
INSERT INTO `test` VALUES (1101, '002', 'fengjiangpi');
COMMIT;

-- ----------------------------
-- Table structure for sys_data_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_data_dict`;
CREATE TABLE `sys_data_dict` (
  `id` bigint(40) NOT NULL,
  `role_session_name` varchar(128) NOT NULL COMMENT '应用名称',
  `field_code` varchar(64) NOT NULL COMMENT '字段名称',
  `item_name` varchar(32) NOT NULL COMMENT '选项名称',
  `item_value` varchar(16) NOT NULL COMMENT '字典KEY',
  `remark` varchar(64) DEFAULT NULL COMMENT '备注',
  `sort` int(11) NOT NULL COMMENT '排序',
  `pid` bigint(40) DEFAULT NULL COMMENT '父级ID',
  `gid` bigint(40) DEFAULT NULL COMMENT '祖级ID',
  `rank` int(11) NOT NULL DEFAULT '0' COMMENT '数据层级',
  `del_flag` tinyint (4) DEFAULT '0' COMMENT '0:正常 1:删除',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for oss_config
-- ----------------------------
DROP TABLE IF EXISTS `oss_config`;
CREATE TABLE `oss_config` (
  `id` bigint(40) NOT NULL,
  `code` varchar(16) NOT NULL COMMENT '授权类型',
  `point` varchar(64) NOT NULL COMMENT 'oss访问地址',
  `bucket` varchar(64) NOT NULL COMMENT '存储实例',
  `access_key_id` varchar(64) NOT NULL COMMENT '账户ID',
  `access_key_secret` varchar(64) NOT NULL COMMENT '账户授权码',
  `out_time` int(16) NOT NULL COMMENT '超时时间（单位：秒）',
  `role_arn` varchar(128) DEFAULT NULL COMMENT '角色名称（临时授权时使用）',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for oss_file
-- ----------------------------
DROP TABLE IF EXISTS `oss_file`;
CREATE TABLE `oss_file` (
  `id` bigint(40) NOT NULL,
  `code` varchar(32) NOT NULL COMMENT '业务场景',
  `bucket` varchar(64) NOT NULL COMMENT '存储实例',
  `file` varchar(64) NOT NULL COMMENT '文件名称',
  `path` varchar(64) NOT NULL COMMENT '存储路径',
  `file_size` bigint(40) NOT NULL COMMENT '附件大小（单位：KB）',
  `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '上传状态 0：未上传    1：已上传',
  `init_file_name` varchar(128) NOT NULL COMMENT '原始文件名',
  `creator` varchar(40) DEFAULT NULL COMMENT '创建者',
  `creator_ip` varchar(40) DEFAULT NULL COMMENT '创建者IP',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS = 1;
